package com.example.demo.entity;


import jakarta.persistence.Entity;
import jakarta.persistence.Id;
import lombok.Data;

import java.math.BigDecimal;

@Data
@Entity
public class produceRepairDetailDTO {
    //WA_produce_wp_in_repair_detail
    @Id
    private Long id;
    //单号
    private String billNo;
    //车间任务单号
    private String productBillNo;
    //物料编号
    private String goodsCode;
    //进仓数量
    private BigDecimal qty;
    //超额进仓数量
    private BigDecimal overQty;
    //总进仓数量
    private BigDecimal totalQty; /*qty+ over_qty*/
    //备注
    private String remark;
    //工序 WA_produce_bill_detail_wp
    private String wpCode;
    //物料名称 V_goods
    private String goodsName;
    //图号-版本/规格
    private String designNumberVerSpec;
    //现存量
    private BigDecimal on_hand_qty;
    //单位
    private String unit_code;

    //可进仓数量
    private BigDecimal canInQty;
            /*(WA_produce_bill_master.combination_bill_no,
	(CASE WA_produce_bill_detail_wp.parm_must_complete_work
                        WHEN 'y' THEN WA_produce_bill_detail_wp.good_qty - WA_produce_bill_detail_wp.in_qty
                        ELSE WA_produce_bill_detail_wp.plan_qty - WA_produce_bill_detail_wp.in_qty
                        END) as can_in_qty)*/

    //工作组 WA_produce_bill_detail_wp
    private String workgroup_code;
    //工作中心
    private String working_center_code;
    //工作区域
    private String working_area_code;
}
